UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nTDnd0bAWNXSIzEwLBfvYcGNV0f0vj8aT6571A9xxqY='
WHERE
key_id = '1b00b7d7c0fee8f24e1c8eb8665cf5b9c70f72b5b8fec400cd77c2a66cb4378f'
AND (
token = 'nTDnd0bAWNXSIzEwLBfvYcGNV0f0vj8aT6571A9xxqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)