UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIrL7N26HrcW//3HTnk49LjRqKs5Z85CtssoL+fAjkM='
WHERE
key_id = '9adbba346258f6b001f9fb8893a7f1647f665dbc38bc3fc486a6827f0650e62b'
AND (
token = 'qIrL7N26HrcW//3HTnk49LjRqKs5Z85CtssoL+fAjkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)