UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HipRnu2pvUfRZGU05fFzqHTfjMGJtn4w/Oq4nCh730o='
WHERE
key_id = '316ab0b6832260294a0ac0cdf0817b55dd06a5df59e97413ed8d6d5d905cab30'
AND (
token = 'HipRnu2pvUfRZGU05fFzqHTfjMGJtn4w/Oq4nCh730o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)