UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXhF/fyXdxOMri1xLcuBt9zvO4nmg5idEY6a8w7B8NI='
WHERE
key_id = '9e181fe8418e035613c3f5c1bc463badf14ed4cea6a1bc419d2adc15b64121fb'
AND (
token = 'QXhF/fyXdxOMri1xLcuBt9zvO4nmg5idEY6a8w7B8NI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)