UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0GzRE1FjmdoeBRkGZQJRg1QGuWVmvfptEwbb/V6j3CY='
WHERE
key_id = '2aed8f5a2987a5671011637f3acb09edde1b2e37651a4f73b197722cc9977324'
AND (
token = '0GzRE1FjmdoeBRkGZQJRg1QGuWVmvfptEwbb/V6j3CY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)