UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't4mzenNgK9LwActIm9+Y9J6A3S6M0JugTxlQBYsyW9s='
WHERE
key_id = 'b24e0904c78d72a36d115beff797e65c7f9e785ecd34eda7a42fb0eb4f22fdfe'
AND (
token = 't4mzenNgK9LwActIm9+Y9J6A3S6M0JugTxlQBYsyW9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)