UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fyeMGjh427zOxxYFq9O98GNxTSEsi8bpZKpGG1u7SI='
WHERE
key_id = '8960d345cbfc503db2738467187d5cf85e12ca4f34122b3b6afb14279a7f227f'
AND (
token = '0fyeMGjh427zOxxYFq9O98GNxTSEsi8bpZKpGG1u7SI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)