UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tH3XiR2+RSpXFPu6ZlQZUFowghB62bY4Z9Z295qa+Co='
WHERE
key_id = 'd7ce93a8d60feb4e1a1a7fb7d37fcf400a49d1e242244cdc41d718a0f65b47f1'
AND (
token = 'tH3XiR2+RSpXFPu6ZlQZUFowghB62bY4Z9Z295qa+Co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)