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