UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zk5mFrKqdLeiX7NeCuaBzkUBbTxE6kNBdBMZ2CWCdVk='
WHERE
key_id = '270536a0e08d2496794305a9b85cf9c6dbe1c72ca289c4cad9dfca923860bcd8'
AND (
token = 'zk5mFrKqdLeiX7NeCuaBzkUBbTxE6kNBdBMZ2CWCdVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)