UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNcq5LexuZQoEJUd+OX7tdV2fXcgtsc0idzOIB98q8U='
WHERE
key_id = 'bb664fbaf307ddb1cc46eb4858e1ea64d91c755fa71f81348ec5c1b5036b793d'
AND (
token = 'QNcq5LexuZQoEJUd+OX7tdV2fXcgtsc0idzOIB98q8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)