UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7RuNjPXoX9SLMizacVoigwyz18Idzg1aWU4kGCdBUfg='
WHERE
key_id = 'c99612a0fe48fd313876f2e8edc7d14c1a9a777d92660a97d1df86be2546ea00'
AND (
token = '7RuNjPXoX9SLMizacVoigwyz18Idzg1aWU4kGCdBUfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)