UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5BX0smTevIB3Widrh/Q1Hotqcf7+Y6BTmmaWXKT+e0='
WHERE
key_id = 'f4d0ea9368983674d7df7d70c83a584cff8e16190c8a2f79793a28cf379dda75'
AND (
token = 'D5BX0smTevIB3Widrh/Q1Hotqcf7+Y6BTmmaWXKT+e0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)