UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqJAc33EeBfMZd4dssAXs35N86dhFB6qvMp2/AdpURM='
WHERE
key_id = 'dd8cab46deabad4d366420da88dbc5f7798dc2ff3c54a838818ccc712b74a670'
AND (
token = 'zqJAc33EeBfMZd4dssAXs35N86dhFB6qvMp2/AdpURM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)