UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jhOm7lCTbscwUVqDg+9Pkmk6SLxQrHfev9J3svdgvo='
WHERE
key_id = 'd73bd7586cdd2aa54a1e45c3120ffd8c070d9a54754312787fbac005ffdcb2d2'
AND (
token = '4jhOm7lCTbscwUVqDg+9Pkmk6SLxQrHfev9J3svdgvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)