UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'duHnKRHX8iFvAJQge2rcLvpULb2qsRSxJD83Y8gX0z8='
WHERE
key_id = '0e673556d6c3dd30365465746d559587dd74a2ed9b136d87560e1d4ef6c0af05'
AND (
token = 'duHnKRHX8iFvAJQge2rcLvpULb2qsRSxJD83Y8gX0z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)