UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xNmFSY/JGcgOrznn8+cHuCOeEkUbzHZ6YDQPj8d+98='
WHERE
key_id = '3d80a130e0cd83bbc864be3825dfa594dd839d3eac5a80b786e29265a3198cf1'
AND (
token = '6xNmFSY/JGcgOrznn8+cHuCOeEkUbzHZ6YDQPj8d+98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)