UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEqYU5YFAaHNiWjGUVBjKmokfrLgEoIrjlKjNK6KUD0='
WHERE
key_id = '6c4efa170c51feec8b22ca6564ac4cecfb456b2c4cf9fa2e213ab834b7bf8615'
AND (
token = 'gEqYU5YFAaHNiWjGUVBjKmokfrLgEoIrjlKjNK6KUD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)