UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZxJyAxIvp0IALnWkj6pXrVs8lP6ewYpRT3+4uc0/pmA='
WHERE
key_id = 'b3a8cb116f5dca2a73a4d6931ce6bd17f0a0705301c27dd37d3e85e376e4de5a'
AND (
token = 'ZxJyAxIvp0IALnWkj6pXrVs8lP6ewYpRT3+4uc0/pmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)