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