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