UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCxlqAAHOs/EPb4PyUkmwGoy3tPsQY0zUIhBhrUbrd4='
WHERE
key_id = 'f469c0c74ff269e62a4cc24b588ccd1ed945a38bd3b34e4a172b3004073fcd34'
AND (
token = 'bCxlqAAHOs/EPb4PyUkmwGoy3tPsQY0zUIhBhrUbrd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)