UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's3YZ47Gx/rM9Uy9CmKzxyyMk2m/YKlmGK1bTIYTSQfU='
WHERE
key_id = 'a312c573410036497f3cfce1b7482a6838b2f5d6b3499c7c6c0c589eab3a6271'
AND (
token = 's3YZ47Gx/rM9Uy9CmKzxyyMk2m/YKlmGK1bTIYTSQfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)