UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9wGkdSWJmZUGaCzeVRL8kvLw/0yebuNv4jLfrbrxDQ='
WHERE
key_id = '3f155a1d23d91f646e0b984de777946a7aeaa178527edff52d42262d0425fa4e'
AND (
token = 'R9wGkdSWJmZUGaCzeVRL8kvLw/0yebuNv4jLfrbrxDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)