UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jbY1i9Pez3qhvtowaRtoNsQF9PBgW/vi8omLUf9Iai0='
WHERE
key_id = 'a7c701c2d3471b4d85636625a27dd0fe50f5a1031d4adf857379248c8745182d'
AND (
token = 'jbY1i9Pez3qhvtowaRtoNsQF9PBgW/vi8omLUf9Iai0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)