UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zDQ1w8bBqJ1CzoMvi+Awqlem+oNhtWBj/5nNQDh5c4='
WHERE
key_id = 'bb6d65ed302cb584b55994deac98369a38d8e72416bb9afc3a68ebcd8e98ae59'
AND (
token = '0zDQ1w8bBqJ1CzoMvi+Awqlem+oNhtWBj/5nNQDh5c4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)