UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzzGqKShgqpvI0yLO0opUmVcy74v0TIaKeka1zWvz9g='
WHERE
key_id = 'a73c4f0f9656677db9f53ef5ac9aa596f69d283f778f84ff24add012dd272dff'
AND (
token = 'hzzGqKShgqpvI0yLO0opUmVcy74v0TIaKeka1zWvz9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)