UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8jvl6dC3F6OrxJ6O3+2PGZ91lIHifK72999o4w+XBU='
WHERE
key_id = '28add43c73f60825ad30a40366f2e76afe1b7cfd19156750afd9c9c15918d1aa'
AND (
token = 'H8jvl6dC3F6OrxJ6O3+2PGZ91lIHifK72999o4w+XBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)