UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XL00a9pMyLn4HJs4nyaQVQ8kPoAW6gKwhRTzMuLhhq0='
WHERE
key_id = '59e2ddf3e07c09ae5b31c9f88c4cc28fda4c1cfa67b2866510d87f2e46692794'
AND (
token = 'XL00a9pMyLn4HJs4nyaQVQ8kPoAW6gKwhRTzMuLhhq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)