UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXss3P/j0zJs6cYg1BzaDWRZm/f2oOLIumQpk7df4yw='
WHERE
key_id = 'd8841aa5567652494917fc28060933847713f2d44002179e104a81e879b4c2df'
AND (
token = 'QXss3P/j0zJs6cYg1BzaDWRZm/f2oOLIumQpk7df4yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)