UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gG7UlUlECRI6dHoNNkkq60djm7C4hZ9AY0yO/XJa490='
WHERE
key_id = '9ad2d92d1272a6e83f53ef7ccbfadc7728d888b52aaaf1bd894118e9142d4962'
AND (
token = 'gG7UlUlECRI6dHoNNkkq60djm7C4hZ9AY0yO/XJa490='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)