UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZAqK6MCjj0VMTld2efTT7JWxB8xJU6V4EPndIfP8As='
WHERE
key_id = 'ef85ad252b0d062ae6975e55b5c981430dc6963a18e5b3871e49840996b00695'
AND (
token = 'CZAqK6MCjj0VMTld2efTT7JWxB8xJU6V4EPndIfP8As='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)