UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JLMWoxScL3CeuaQFHQBb6aW8YpbW1LZxwnRPN8ySUcA='
WHERE
key_id = '07477c997b2c35860c20ca8f1c0f595664532caef198306f0b1d612206a0318b'
AND (
token = 'JLMWoxScL3CeuaQFHQBb6aW8YpbW1LZxwnRPN8ySUcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)